DROP TABLE IF EXISTS `reviewer_dk_db`.`members`;
CREATE TABLE  `reviewer_dk_db`.`members` (
  `Id` char(36) NOT NULL,
  `Username` varchar(255) NOT NULL,
  `ApplicationName` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Comment` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `PasswordQuestion` varchar(255),
  `PasswordAnswer` varchar(255),
  `IsApproved` bit,
  `LastActivityDate` datetime,
  `LastLoginDate` datetime,
  `LastPasswordChangedDate` datetime,
  `CreationDate` datetime,
  `IsOnline` bit,
  `IsLockedOut` bit,
  `LastLockedOutDate` datetime,
  `FailedPasswordAttemptCount` integer,
  `FailedPasswordAttemptWindowStart` datetime,
  `FailedPasswordAnswerAttemptCount` integer,
  `FailedPasswordAnswerAttemptWindowStart` datetime,
  `Format`integer NOT NULL,
  `AnswerFormat`integer NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;